﻿// * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
// Copyright (c) 2011, Dr. Masroor Ehsan
// All rights reserved.
// 
// Redistribution and use in source and binary forms, with or without
// modification, are permitted provided that the following conditions are met:
//     * Redistributions of source code must retain the above copyright
//       notice, this list of conditions and the following disclaimer.
//     * Redistributions in binary form must reproduce the above copyright
//       notice, this list of conditions and the following disclaimer in the
//       documentation and/or other materials provided with the distribution.
//     * Neither the name of the author nor the
//       names of its contributors may be used to endorse or promote products
//       derived from this software without specific prior written permission.
// 
// THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND
// ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
// WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
// DISCLAIMED. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR ANY
// DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
// (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
// LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
// ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
// (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
// SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
// 
// $Author:$
// $Id:$
// $Rev:$
// * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

using MaxTrader.BusinessObjects;

namespace MaxTrader.DAL.Mapping
{
    public sealed class StockSymbolMap : EntityMap<StockSymbol>
    {
        public StockSymbolMap()
        {
            var className = typeof (StockSymbol).Name;

            Table(Mapping.GetTableName(className));

            Id(x => x.Id)
                .Column(Mapping.GetColumnName(className, "Id"))
                .GeneratedBy.Sequence(Mapping.GetGeneratorName(className));

            Map(x => x.Category)
                .Column(Mapping.GetColumnName(className, "Category"))
                .CustomType<MarketCategory>()
                .Index(Mapping.IndexName(className, "Category"))
                .Not.Nullable();

            Map(x => x.CseId)
                .Column(Mapping.GetColumnName(className, "CseId"))
                .Index(Mapping.IndexName(className, "CseId"))
                .Length(16);

            Map(x => x.CseSymbol)
                .Column(Mapping.GetColumnName(className, "CseSymbol"))
                .Index(Mapping.IndexName(className, "CseSymbol"))
                .Length(80);

            Map(x => x.DseId)
                .Column(Mapping.GetColumnName(className, "DseId"))
                .Index(Mapping.IndexName(className, "DseId"))
                .Length(16);

            Map(x => x.DseSymbol)
                .Column(Mapping.GetColumnName(className, "DseSymbol"))
                .Index(Mapping.IndexName(className, "DseSymbol"))
                .Length(80);

            Map(x => x.CompanyName)
                .Column(Mapping.GetColumnName(className, "CompanyName"));

            References(x => x.Sector, Mapping.GetColumnName(className, "Sector"))
                .ForeignKey(Mapping.ForeignKeyName(className, "Sector"))
                .Not.Nullable()
                .Cascade.All();
        }
    }
}